Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 1127650 |
| Missing cells | 30 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 106.5 MiB |
| Average record size in memory | 99.0 B |
Variable types
| Categorical | 2 |
|---|---|
| DateTime | 3 |
| Numeric | 8 |
ch_cpf_hash has a high cardinality: 225530 distinct values | High cardinality |
vl_min_limite_aprovado is highly overall correlated with vl_max_limite_aprovado and 1 other fields | High correlation |
vl_max_limite_aprovado is highly overall correlated with vl_min_limite_aprovado and 1 other fields | High correlation |
vl_total_limite_aprovado is highly overall correlated with vl_min_limite_aprovado and 2 other fields | High correlation |
min_saldo_devedor is highly overall correlated with max_saldo_devedor and 1 other fields | High correlation |
max_saldo_devedor is highly overall correlated with min_saldo_devedor and 1 other fields | High correlation |
total_saldo_devedor is highly overall correlated with min_saldo_devedor and 1 other fields | High correlation |
min_dias_atraso is highly overall correlated with max_dias_atraso | High correlation |
max_dias_atraso is highly overall correlated with min_dias_atraso | High correlation |
vl_qnt_conta is highly overall correlated with vl_total_limite_aprovado | High correlation |
vl_qnt_conta is highly imbalanced (99.8%) | Imbalance |
ch_cpf_hash is uniformly distributed | Uniform |
min_saldo_devedor has 167362 (14.8%) zeros | Zeros |
max_saldo_devedor has 167331 (14.8%) zeros | Zeros |
total_saldo_devedor has 167284 (14.8%) zeros | Zeros |
min_dias_atraso has 767362 (68.0%) zeros | Zeros |
max_dias_atraso has 767268 (68.0%) zeros | Zeros |
Reproduction
| Analysis started | 2024-11-22 20:46:06.910942 |
|---|---|
| Analysis finished | 2024-11-22 20:46:43.825097 |
| Duration | 36.91 seconds |
| Software version | pandas-profiling v0.0.dev0 |
| Download configuration | config.json |
ch_cpf_hash
Categorical
HIGH CARDINALITY UNIFORM
| Distinct | 225530 |
|---|---|
| Distinct (%) | 20.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.6 MiB |
| 0da564d51ee1ce79bd60bd0b723238c3878aa1d54d6da4ae1619be8de3c5dde9 | 5 |
|---|---|
| 8b5702cc48fc721533b162ea7b3873d3701b61e0330f3df8b10bea93865cbd5c | 5 |
| 008d214e8b13b0e92be2f88dd6433d2a8f21d98970ad57834fb6eacfd0a29df5 | 5 |
| 542a5598a7d9dcb5f81a5144dba67fed635593d7d2230b2c4c6550500b1c0d46 | 5 |
| 9326ccdb50621a8d89850305b3babdde6ba95b91f43edb08f828233e8d49af56 | 5 |
| Other values (225525) |
Length
| Max length | 64 |
|---|---|
| Median length | 64 |
| Mean length | 64 |
| Min length | 64 |
Characters and Unicode
| Total characters | 72169600 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0da564d51ee1ce79bd60bd0b723238c3878aa1d54d6da4ae1619be8de3c5dde9 |
|---|---|
| 2nd row | d2a444414ab222bf58b39090d7e64a66b2c1cdef2dad370a67b7b8b7d80297d5 |
| 3rd row | 39e26353f2a9de3b00f2ff1a50bcaaad04101251e794c9117f7506e0a170e5b0 |
| 4th row | b87362d224305c9c0f08fcc98df0e0703cb159b5bb2ea7d265b5d729678e0906 |
| 5th row | f9978d9d96ae87331838f3eff26f19d78df9a8d52853a29e2d471bda7a1f313b |
Common Values
| Value | Count | Frequency (%) |
| 0da564d51ee1ce79bd60bd0b723238c3878aa1d54d6da4ae1619be8de3c5dde9 | 5 | < 0.1% |
| 8b5702cc48fc721533b162ea7b3873d3701b61e0330f3df8b10bea93865cbd5c | 5 | < 0.1% |
| 008d214e8b13b0e92be2f88dd6433d2a8f21d98970ad57834fb6eacfd0a29df5 | 5 | < 0.1% |
| 542a5598a7d9dcb5f81a5144dba67fed635593d7d2230b2c4c6550500b1c0d46 | 5 | < 0.1% |
| 9326ccdb50621a8d89850305b3babdde6ba95b91f43edb08f828233e8d49af56 | 5 | < 0.1% |
| 39e26353f2a9de3b00f2ff1a50bcaaad04101251e794c9117f7506e0a170e5b0 | 5 | < 0.1% |
| b87362d224305c9c0f08fcc98df0e0703cb159b5bb2ea7d265b5d729678e0906 | 5 | < 0.1% |
| f9978d9d96ae87331838f3eff26f19d78df9a8d52853a29e2d471bda7a1f313b | 5 | < 0.1% |
| bf653baaa25761c0b618b7ab8bb658e3e3530724be75b19cac47f4aeaa654265 | 5 | < 0.1% |
| af4b161d2249ef8459e23d74bc0716c6970231d1a66bcd2f7f9b1867ed9982a0 | 5 | < 0.1% |
| Other values (225520) | 1127600 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 0da564d51ee1ce79bd60bd0b723238c3878aa1d54d6da4ae1619be8de3c5dde9 | 5 | < 0.1% |
| fc0da3de1876b85db46e1ad94476b8536d40a2170ab633d04fb15f59e84d8bac | 5 | < 0.1% |
| 3b38be82fb6949af2f7840549a296d82b5623b57b13383a085480d8c557c086c | 5 | < 0.1% |
| b42352efb354e34f16f827edb2c7dcc72db96c62789fc5508f9ccde02377b447 | 5 | < 0.1% |
| 28714477c047e7a8cef2cba2c4374bef7eb4fdecc1305138aee9d44b1f04ef16 | 5 | < 0.1% |
| d994cf330a7f7e787d55773700e67e6967cf92816f50d792030e57880e932d9f | 5 | < 0.1% |
| 738178a373196d191b15834a0c0d23c60db1db835bd5bb0ad42f3c041b9eabc0 | 5 | < 0.1% |
| 5e02e2406d3c5dcece6b8bf6a5792118b3b6b5dbe7d8f8a52e5281702f29724b | 5 | < 0.1% |
| 3147f2869c59bf026ac22fc7be5ac3f8447a9d70c76973be9508449fb770588c | 5 | < 0.1% |
| 9c422b6561491a8ce9762b19b5a3eec963b6909a77d270b4ec03b85fbbaa0896 | 5 | < 0.1% |
| Other values (225520) | 1127600 |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 4519320 | 6.3% |
| 4 | 4518455 | 6.3% |
| f | 4517350 | 6.3% |
| 0 | 4515915 | 6.3% |
| 6 | 4513735 | 6.3% |
| 1 | 4511860 | 6.3% |
| 9 | 4511810 | 6.3% |
| 5 | 4511550 | 6.3% |
| b | 4510695 | 6.3% |
| 8 | 4509760 | 6.2% |
| Other values (6) | 27029150 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 45111635 | |
| Lowercase Letter | 27057965 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 4518455 | |
| 0 | 4515915 | |
| 6 | 4513735 | |
| 1 | 4511860 | |
| 9 | 4511810 | |
| 5 | 4511550 | |
| 8 | 4509760 | |
| 2 | 4509665 | |
| 7 | 4505625 | |
| 3 | 4503260 |
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 4519320 | |
| f | 4517350 | |
| b | 4510695 | |
| d | 4508015 | |
| a | 4501940 | |
| e | 4500645 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 45111635 | |
| Latin | 27057965 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 4 | 4518455 | |
| 0 | 4515915 | |
| 6 | 4513735 | |
| 1 | 4511860 | |
| 9 | 4511810 | |
| 5 | 4511550 | |
| 8 | 4509760 | |
| 2 | 4509665 | |
| 7 | 4505625 | |
| 3 | 4503260 |
Latin
| Value | Count | Frequency (%) |
| c | 4519320 | |
| f | 4517350 | |
| b | 4510695 | |
| d | 4508015 | |
| a | 4501940 | |
| e | 4500645 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72169600 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 4519320 | 6.3% |
| 4 | 4518455 | 6.3% |
| f | 4517350 | 6.3% |
| 0 | 4515915 | 6.3% |
| 6 | 4513735 | 6.3% |
| 1 | 4511860 | 6.3% |
| 9 | 4511810 | 6.3% |
| 5 | 4511550 | 6.3% |
| b | 4510695 | 6.3% |
| 8 | 4509760 | 6.2% |
| Other values (6) | 27029150 |
vl_qnt_conta
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.6 MiB |
| 1 | |
|---|---|
| 2 | 330 |
| 54 | 5 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0000044 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1127655 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 1127315 | |
| 2 | 330 | < 0.1% |
| 54 | 5 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 1127315 | |
| 2 | 330 | < 0.1% |
| 54 | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 1127315 | |
| 2 | 330 | < 0.1% |
| 5 | 5 | < 0.1% |
| 4 | 5 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1127655 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1127315 | |
| 2 | 330 | < 0.1% |
| 5 | 5 | < 0.1% |
| 4 | 5 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1127655 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 1127315 | |
| 2 | 330 | < 0.1% |
| 5 | 5 | < 0.1% |
| 4 | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1127655 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 1127315 | |
| 2 | 330 | < 0.1% |
| 5 | 5 | < 0.1% |
| 4 | 5 | < 0.1% |
dt_min_adesao
Date
| Distinct | 2106 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.6 MiB |
| Minimum | 2016-09-14 00:00:00 |
|---|---|
| Maximum | 2024-04-05 00:00:00 |
Histogram with fixed size bins (bins=50)
dt_max_adesao
Date
| Distinct | 2106 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.6 MiB |
| Minimum | 2016-09-14 00:00:00 |
|---|---|
| Maximum | 2024-04-05 00:00:00 |
Histogram with fixed size bins (bins=50)
vl_min_limite_aprovado
Real number (ℝ)
| Distinct | 229 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2124.7229 |
| Minimum | 0 |
|---|---|
| Maximum | 12500 |
| Zeros | 45 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 1100 |
| median | 1800 |
| Q3 | 2600 |
| 95-th percentile | 5000 |
| Maximum | 12500 |
| Range | 12500 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 1622.0309 |
|---|---|
| Coefficient of variation (CV) | 0.76340821 |
| Kurtosis | 11.444531 |
| Mean | 2124.7229 |
| Median Absolute Deviation (MAD) | 700 |
| Skewness | 2.7459947 |
| Sum | 2.3959225 × 109 |
| Variance | 2630984.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 85125 | 7.5% |
| 2000 | 54735 | 4.9% |
| 1300 | 54405 | 4.8% |
| 1500 | 51160 | 4.5% |
| 1000 | 44965 | 4.0% |
| 1700 | 43015 | 3.8% |
| 1200 | 41995 | 3.7% |
| 1800 | 41835 | 3.7% |
| 1400 | 40530 | 3.6% |
| 1100 | 39355 | 3.5% |
| Other values (219) | 630520 |
| Value | Count | Frequency (%) |
| 0 | 45 | < 0.1% |
| 100 | 15 | < 0.1% |
| 300 | 5 | < 0.1% |
| 500 | 39035 | |
| 600 | 85125 | |
| 700 | 29610 | 2.6% |
| 727.21 | 5 | < 0.1% |
| 800 | 25515 | 2.3% |
| 841.42 | 5 | < 0.1% |
| 900 | 31705 | 2.8% |
| Value | Count | Frequency (%) |
| 12500 | 4900 | |
| 12400 | 75 | < 0.1% |
| 12300 | 85 | < 0.1% |
| 12200 | 65 | < 0.1% |
| 12100 | 60 | < 0.1% |
| 12000 | 410 | < 0.1% |
| 11900 | 135 | < 0.1% |
| 11800 | 115 | < 0.1% |
| 11700 | 75 | < 0.1% |
| 11600 | 130 | < 0.1% |
vl_max_limite_aprovado
Real number (ℝ)
| Distinct | 227 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2125.1251 |
| Minimum | 0 |
|---|---|
| Maximum | 12500 |
| Zeros | 45 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 1100 |
| median | 1800 |
| Q3 | 2600 |
| 95-th percentile | 5000 |
| Maximum | 12500 |
| Range | 12500 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 1622.3318 |
|---|---|
| Coefficient of variation (CV) | 0.76340533 |
| Kurtosis | 11.440301 |
| Mean | 2125.1251 |
| Median Absolute Deviation (MAD) | 700 |
| Skewness | 2.7455514 |
| Sum | 2.3963761 × 109 |
| Variance | 2631960.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 85100 | 7.5% |
| 2000 | 54735 | 4.9% |
| 1300 | 54400 | 4.8% |
| 1500 | 51155 | 4.5% |
| 1000 | 44965 | 4.0% |
| 1700 | 43020 | 3.8% |
| 1200 | 41990 | 3.7% |
| 1800 | 41820 | 3.7% |
| 1400 | 40515 | 3.6% |
| 1100 | 39345 | 3.5% |
| Other values (217) | 630595 |
| Value | Count | Frequency (%) |
| 0 | 45 | < 0.1% |
| 100 | 15 | < 0.1% |
| 300 | 5 | < 0.1% |
| 500 | 39020 | |
| 600 | 85100 | |
| 700 | 29595 | 2.6% |
| 727.21 | 5 | < 0.1% |
| 800 | 25505 | 2.3% |
| 841.42 | 5 | < 0.1% |
| 900 | 31700 | 2.8% |
| Value | Count | Frequency (%) |
| 12500 | 4905 | |
| 12400 | 75 | < 0.1% |
| 12300 | 85 | < 0.1% |
| 12200 | 65 | < 0.1% |
| 12100 | 60 | < 0.1% |
| 12000 | 410 | < 0.1% |
| 11900 | 135 | < 0.1% |
| 11800 | 115 | < 0.1% |
| 11700 | 75 | < 0.1% |
| 11600 | 130 | < 0.1% |
vl_total_limite_aprovado
Real number (ℝ)
| Distinct | 238 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2126.6723 |
| Minimum | 0 |
|---|---|
| Maximum | 96700 |
| Zeros | 45 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 1100 |
| median | 1800 |
| Q3 | 2600 |
| 95-th percentile | 5000 |
| Maximum | 96700 |
| Range | 96700 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 1636.7232 |
|---|---|
| Coefficient of variation (CV) | 0.76961703 |
| Kurtosis | 60.529729 |
| Mean | 2126.6723 |
| Median Absolute Deviation (MAD) | 700 |
| Skewness | 3.5454227 |
| Sum | 2.3981207 × 109 |
| Variance | 2678862.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 85080 | 7.5% |
| 2000 | 54737 | 4.9% |
| 1300 | 54386 | 4.8% |
| 1500 | 51138 | 4.5% |
| 1000 | 44947 | 4.0% |
| 1700 | 42994 | 3.8% |
| 1200 | 41995 | 3.7% |
| 1800 | 41796 | 3.7% |
| 1400 | 40503 | 3.6% |
| 1100 | 39338 | 3.5% |
| Other values (228) | 630726 |
| Value | Count | Frequency (%) |
| 0 | 45 | < 0.1% |
| 100 | 15 | < 0.1% |
| 300 | 5 | < 0.1% |
| 500 | 39003 | |
| 600 | 85080 | |
| 700 | 29593 | 2.6% |
| 727.21 | 5 | < 0.1% |
| 800 | 25495 | 2.3% |
| 841.42 | 5 | < 0.1% |
| 900 | 31696 | 2.8% |
| Value | Count | Frequency (%) |
| 96700 | 5 | < 0.1% |
| 25000 | 2 | < 0.1% |
| 22000 | 1 | < 0.1% |
| 17000 | 1 | < 0.1% |
| 16500 | 5 | < 0.1% |
| 16400 | 2 | < 0.1% |
| 15300 | 5 | < 0.1% |
| 14400 | 2 | < 0.1% |
| 13000 | 1 | < 0.1% |
| 12500 | 4898 |
min_saldo_devedor
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 295712 |
|---|---|
| Distinct (%) | 26.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1270.6353 |
| Minimum | -12464.4 |
|---|---|
| Maximum | 56578.72 |
| Zeros | 167362 |
| Zeros (%) | 14.8% |
| Negative | 164630 |
| Negative (%) | 14.6% |
| Memory size | 8.6 MiB |
Quantile statistics
| Minimum | -12464.4 |
|---|---|
| 5-th percentile | -11.7955 |
| Q1 | 0 |
| median | 210 |
| Q3 | 1501.36 |
| 95-th percentile | 6017.18 |
| Maximum | 56578.72 |
| Range | 69043.12 |
| Interquartile range (IQR) | 1501.36 |
Descriptive statistics
| Standard deviation | 2404.5248 |
|---|---|
| Coefficient of variation (CV) | 1.89238 |
| Kurtosis | 23.522805 |
| Mean | 1270.6353 |
| Median Absolute Deviation (MAD) | 219.38 |
| Skewness | 3.7005457 |
| Sum | 1.4328319 × 109 |
| Variance | 5781739.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 167362 | 14.8% |
| 13.9 | 8993 | 0.8% |
| 0.02 | 7502 | 0.7% |
| 0.04 | 5345 | 0.5% |
| 0.06 | 5061 | 0.4% |
| 0.03 | 4402 | 0.4% |
| 0.01 | 4119 | 0.4% |
| 0.05 | 3882 | 0.3% |
| 0.07 | 2942 | 0.3% |
| -0.01 | 2899 | 0.3% |
| Other values (295702) | 915143 |
| Value | Count | Frequency (%) |
| -12464.4 | 5 | |
| -8303.4 | 1 | < 0.1% |
| -8300.36 | 1 | < 0.1% |
| -7842.1 | 1 | < 0.1% |
| -7826.91 | 5 | |
| -7380.8 | 1 | < 0.1% |
| -6919.5 | 1 | < 0.1% |
| -6481.42 | 1 | < 0.1% |
| -6458.2 | 1 | < 0.1% |
| -5939.45 | 5 |
| Value | Count | Frequency (%) |
| 56578.72 | 1 | < 0.1% |
| 55849.74 | 5 | |
| 55399.84 | 4 | |
| 50193.99 | 5 | |
| 46176.53 | 5 | |
| 46121.41 | 5 | |
| 44642.1 | 1 | < 0.1% |
| 44320.22 | 1 | < 0.1% |
| 43644.07 | 1 | < 0.1% |
| 43553.86 | 1 | < 0.1% |
max_saldo_devedor
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 295764 |
|---|---|
| Distinct (%) | 26.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1271.0835 |
| Minimum | -12464.4 |
|---|---|
| Maximum | 56578.72 |
| Zeros | 167331 |
| Zeros (%) | 14.8% |
| Negative | 164429 |
| Negative (%) | 14.6% |
| Memory size | 8.6 MiB |
Quantile statistics
| Minimum | -12464.4 |
|---|---|
| 5-th percentile | -11.76 |
| Q1 | 0 |
| median | 210.565 |
| Q3 | 1502.1575 |
| 95-th percentile | 6018.222 |
| Maximum | 56578.72 |
| Range | 69043.12 |
| Interquartile range (IQR) | 1502.1575 |
Descriptive statistics
| Standard deviation | 2404.7405 |
|---|---|
| Coefficient of variation (CV) | 1.8918824 |
| Kurtosis | 23.51215 |
| Mean | 1271.0835 |
| Median Absolute Deviation (MAD) | 219.875 |
| Skewness | 3.6995788 |
| Sum | 1.4333373 × 109 |
| Variance | 5782776.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 167331 | 14.8% |
| 13.9 | 8992 | 0.8% |
| 0.02 | 7492 | 0.7% |
| 0.04 | 5350 | 0.5% |
| 0.06 | 5061 | 0.4% |
| 0.03 | 4402 | 0.4% |
| 0.01 | 4124 | 0.4% |
| 0.05 | 3887 | 0.3% |
| 0.07 | 2947 | 0.3% |
| -0.01 | 2888 | 0.3% |
| Other values (295754) | 915176 |
| Value | Count | Frequency (%) |
| -12464.4 | 5 | |
| -8303.4 | 1 | < 0.1% |
| -8300.36 | 1 | < 0.1% |
| -7842.1 | 1 | < 0.1% |
| -7826.91 | 5 | |
| -7380.8 | 1 | < 0.1% |
| -6919.5 | 1 | < 0.1% |
| -6481.42 | 1 | < 0.1% |
| -6458.2 | 1 | < 0.1% |
| -5939.45 | 5 |
| Value | Count | Frequency (%) |
| 56578.72 | 1 | < 0.1% |
| 55849.74 | 5 | |
| 55399.84 | 4 | |
| 50193.99 | 5 | |
| 46176.53 | 5 | |
| 46121.41 | 5 | |
| 44642.1 | 1 | < 0.1% |
| 44320.22 | 1 | < 0.1% |
| 43644.07 | 1 | < 0.1% |
| 43553.86 | 1 | < 0.1% |
total_saldo_devedor
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 295802 |
|---|---|
| Distinct (%) | 26.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1271.4184 |
| Minimum | -12464.4 |
|---|---|
| Maximum | 56578.72 |
| Zeros | 167284 |
| Zeros (%) | 14.8% |
| Negative | 164522 |
| Negative (%) | 14.6% |
| Memory size | 8.6 MiB |
Quantile statistics
| Minimum | -12464.4 |
|---|---|
| 5-th percentile | -11.78 |
| Q1 | 0 |
| median | 210.57 |
| Q3 | 1502.45 |
| 95-th percentile | 6019.722 |
| Maximum | 56578.72 |
| Range | 69043.12 |
| Interquartile range (IQR) | 1502.45 |
Descriptive statistics
| Standard deviation | 2405.4416 |
|---|---|
| Coefficient of variation (CV) | 1.8919355 |
| Kurtosis | 23.495039 |
| Mean | 1271.4184 |
| Median Absolute Deviation (MAD) | 219.91 |
| Skewness | 3.6988423 |
| Sum | 1.4337149 × 109 |
| Variance | 5786149.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 167284 | 14.8% |
| 13.9 | 8991 | 0.8% |
| 0.02 | 7492 | 0.7% |
| 0.04 | 5345 | 0.5% |
| 0.06 | 5061 | 0.4% |
| 0.03 | 4402 | 0.4% |
| 0.01 | 4119 | 0.4% |
| 0.05 | 3877 | 0.3% |
| 0.07 | 2942 | 0.3% |
| -0.01 | 2888 | 0.3% |
| Other values (295792) | 915249 |
| Value | Count | Frequency (%) |
| -12464.4 | 5 | |
| -8303.4 | 1 | < 0.1% |
| -8300.36 | 1 | < 0.1% |
| -7842.1 | 1 | < 0.1% |
| -7826.91 | 5 | |
| -7380.8 | 1 | < 0.1% |
| -6919.5 | 1 | < 0.1% |
| -6481.42 | 1 | < 0.1% |
| -6458.2 | 1 | < 0.1% |
| -5939.45 | 5 |
| Value | Count | Frequency (%) |
| 56578.72 | 1 | < 0.1% |
| 55849.74 | 5 | |
| 55399.84 | 4 | |
| 50193.99 | 5 | |
| 46176.53 | 5 | |
| 46121.41 | 5 | |
| 44642.1 | 1 | < 0.1% |
| 44320.22 | 1 | < 0.1% |
| 43644.07 | 1 | < 0.1% |
| 43553.86 | 1 | < 0.1% |
min_dias_atraso
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1067 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104.92519 |
| Minimum | 0 |
|---|---|
| Maximum | 2762 |
| Zeros | 767362 |
| Zeros (%) | 68.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 144 |
| 95-th percentile | 571 |
| Maximum | 2762 |
| Range | 2762 |
| Interquartile range (IQR) | 144 |
Descriptive statistics
| Standard deviation | 232.5313 |
|---|---|
| Coefficient of variation (CV) | 2.2161628 |
| Kurtosis | 22.489317 |
| Mean | 104.92519 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.9059835 |
| Sum | 1.1831889 × 108 |
| Variance | 54070.806 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 767362 | |
| 296 | 8004 | 0.7% |
| 7 | 7555 | 0.7% |
| 265 | 7176 | 0.6% |
| 281 | 7041 | 0.6% |
| 250 | 6592 | 0.6% |
| 6 | 5944 | 0.5% |
| 291 | 5642 | 0.5% |
| 189 | 5399 | 0.5% |
| 204 | 5312 | 0.5% |
| Other values (1057) | 301623 | 26.7% |
| Value | Count | Frequency (%) |
| 0 | 767362 | |
| 6 | 5944 | 0.5% |
| 7 | 7555 | 0.7% |
| 11 | 1836 | 0.2% |
| 12 | 2557 | 0.2% |
| 16 | 1856 | 0.2% |
| 17 | 2334 | 0.2% |
| 20 | 1 | < 0.1% |
| 21 | 1678 | 0.1% |
| 22 | 2116 | 0.2% |
| Value | Count | Frequency (%) |
| 2762 | 1 | < 0.1% |
| 2747 | 1 | < 0.1% |
| 2731 | 1 | < 0.1% |
| 2717 | 1 | < 0.1% |
| 2716 | 1 | < 0.1% |
| 2710 | 1 | < 0.1% |
| 2706 | 1 | < 0.1% |
| 2701 | 3 | |
| 2686 | 4 | |
| 2679 | 1 | < 0.1% |
max_dias_atraso
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 1067 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 105.02991 |
| Minimum | 0 |
|---|---|
| Maximum | 2762 |
| Zeros | 767268 |
| Zeros (%) | 68.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 5.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 144 |
| 95-th percentile | 574 |
| Maximum | 2762 |
| Range | 2762 |
| Interquartile range (IQR) | 144 |
Descriptive statistics
| Standard deviation | 232.89859 |
|---|---|
| Coefficient of variation (CV) | 2.21745 |
| Kurtosis | 22.543779 |
| Mean | 105.02991 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.912082 |
| Sum | 1.1843698 × 108 |
| Variance | 54241.751 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 767268 | |
| 296 | 8005 | 0.7% |
| 7 | 7555 | 0.7% |
| 265 | 7177 | 0.6% |
| 281 | 7042 | 0.6% |
| 250 | 6593 | 0.6% |
| 6 | 5956 | 0.5% |
| 291 | 5643 | 0.5% |
| 189 | 5399 | 0.5% |
| 204 | 5312 | 0.5% |
| Other values (1057) | 301700 | 26.8% |
| Value | Count | Frequency (%) |
| 0 | 767268 | |
| 6 | 5956 | 0.5% |
| 7 | 7555 | 0.7% |
| 11 | 1841 | 0.2% |
| 12 | 2558 | 0.2% |
| 16 | 1857 | 0.2% |
| 17 | 2334 | 0.2% |
| 20 | 1 | < 0.1% |
| 21 | 1678 | 0.1% |
| 22 | 2113 | 0.2% |
| Value | Count | Frequency (%) |
| 2762 | 1 | < 0.1% |
| 2747 | 1 | < 0.1% |
| 2731 | 1 | < 0.1% |
| 2717 | 1 | < 0.1% |
| 2716 | 1 | < 0.1% |
| 2710 | 1 | < 0.1% |
| 2706 | 1 | < 0.1% |
| 2701 | 3 | |
| 2686 | 4 | |
| 2679 | 1 | < 0.1% |
dt_fechamento
Date
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 8.6 MiB |
| Minimum | 2024-06-30 00:00:00 |
|---|---|
| Maximum | 2024-10-31 00:00:00 |
Histogram with fixed size bins (bins=5)
| vl_min_limite_aprovado | vl_max_limite_aprovado | vl_total_limite_aprovado | min_saldo_devedor | max_saldo_devedor | total_saldo_devedor | min_dias_atraso | max_dias_atraso | vl_qnt_conta | |
|---|---|---|---|---|---|---|---|---|---|
| vl_min_limite_aprovado | 1.000 | 1.000 | 0.999 | 0.031 | 0.031 | 0.031 | -0.044 | -0.044 | 0.003 |
| vl_max_limite_aprovado | 1.000 | 1.000 | 1.000 | 0.030 | 0.031 | 0.031 | -0.044 | -0.044 | 0.013 |
| vl_total_limite_aprovado | 0.999 | 1.000 | 1.000 | 0.030 | 0.031 | 0.031 | -0.044 | -0.044 | 0.707 |
| min_saldo_devedor | 0.031 | 0.030 | 0.030 | 1.000 | 1.000 | 1.000 | 0.176 | 0.176 | 0.007 |
| max_saldo_devedor | 0.031 | 0.031 | 0.031 | 1.000 | 1.000 | 1.000 | 0.176 | 0.176 | 0.003 |
| total_saldo_devedor | 0.031 | 0.031 | 0.031 | 1.000 | 1.000 | 1.000 | 0.176 | 0.176 | 0.003 |
| min_dias_atraso | -0.044 | -0.044 | -0.044 | 0.176 | 0.176 | 0.176 | 1.000 | 1.000 | 0.003 |
| max_dias_atraso | -0.044 | -0.044 | -0.044 | 0.176 | 0.176 | 0.176 | 1.000 | 1.000 | 0.040 |
| vl_qnt_conta | 0.003 | 0.013 | 0.707 | 0.007 | 0.003 | 0.003 | 0.003 | 0.040 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| ch_cpf_hash | vl_qnt_conta | dt_min_adesao | dt_max_adesao | vl_min_limite_aprovado | vl_max_limite_aprovado | vl_total_limite_aprovado | min_saldo_devedor | max_saldo_devedor | total_saldo_devedor | min_dias_atraso | max_dias_atraso | dt_fechamento | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0da564d51ee1ce79bd60bd0b723238c3878aa1d54d6da4ae1619be8de3c5dde9 | 1 | 2021-12-27 | 2021-12-27 | 600.0 | 600.0 | 600.0 | 307.78 | 307.78 | 307.78 | 149 | 149 | 2024-08-31 |
| 1 | d2a444414ab222bf58b39090d7e64a66b2c1cdef2dad370a67b7b8b7d80297d5 | 1 | 2021-12-28 | 2021-12-28 | 1900.0 | 1900.0 | 1900.0 | 2592.25 | 2592.25 | 2592.25 | 220 | 220 | 2024-08-31 |
| 2 | 39e26353f2a9de3b00f2ff1a50bcaaad04101251e794c9117f7506e0a170e5b0 | 1 | 2022-01-06 | 2022-01-06 | 1800.0 | 1800.0 | 1800.0 | 0.00 | 0.00 | 0.00 | 0 | 0 | 2024-08-31 |
| 3 | b87362d224305c9c0f08fcc98df0e0703cb159b5bb2ea7d265b5d729678e0906 | 1 | 2022-01-13 | 2022-01-13 | 700.0 | 700.0 | 700.0 | 653.46 | 653.46 | 653.46 | 114 | 114 | 2024-08-31 |
| 4 | f9978d9d96ae87331838f3eff26f19d78df9a8d52853a29e2d471bda7a1f313b | 1 | 2022-01-13 | 2022-01-13 | 6100.0 | 6100.0 | 6100.0 | 83.40 | 83.40 | 83.40 | 38 | 38 | 2024-08-31 |
| 5 | bf653baaa25761c0b618b7ab8bb658e3e3530724be75b19cac47f4aeaa654265 | 1 | 2022-01-19 | 2022-01-19 | 1800.0 | 1800.0 | 1800.0 | 0.01 | 0.01 | 0.01 | 0 | 0 | 2024-08-31 |
| 6 | af4b161d2249ef8459e23d74bc0716c6970231d1a66bcd2f7f9b1867ed9982a0 | 1 | 2022-01-27 | 2022-01-27 | 1800.0 | 1800.0 | 1800.0 | 1313.07 | 1313.07 | 1313.07 | 109 | 109 | 2024-08-31 |
| 7 | 3d79d5e702a97715c8ae7156867aaa2dcb9d39cf512874981b066d7216812e12 | 1 | 2022-02-03 | 2022-02-03 | 2400.0 | 2400.0 | 2400.0 | -17.14 | -17.14 | -17.14 | 0 | 0 | 2024-08-31 |
| 8 | 5d1bbd70f4faec47499608dd2ae1544b416672f1ccdc6c870142cbdbcc07f5b3 | 1 | 2022-02-04 | 2022-02-04 | 3000.0 | 3000.0 | 3000.0 | -2.99 | -2.99 | -2.99 | 0 | 0 | 2024-08-31 |
| 9 | 78f0dafad3f47eab57095e6fa19ef2ff3e0c30f95d8fe2c6cd4defc9012d79d9 | 1 | 2022-02-07 | 2022-02-07 | 4100.0 | 4100.0 | 4100.0 | 0.08 | 0.08 | 0.08 | 0 | 0 | 2024-08-31 |
| ch_cpf_hash | vl_qnt_conta | dt_min_adesao | dt_max_adesao | vl_min_limite_aprovado | vl_max_limite_aprovado | vl_total_limite_aprovado | min_saldo_devedor | max_saldo_devedor | total_saldo_devedor | min_dias_atraso | max_dias_atraso | dt_fechamento | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1127640 | bc45f21a532d04cfb55eb92a9a2366c467d5a78fc806480de2cabab927278f28 | 1 | 2022-01-17 | 2022-01-17 | 5400.0 | 5400.0 | 5400.0 | 99.11 | 99.11 | 99.11 | 37 | 37 | 2024-07-31 |
| 1127641 | 54bada5ba31ec97f93c061b77c32a2bff3d986f22efb52a26461e456b6336c16 | 1 | 2022-01-27 | 2022-01-27 | 1900.0 | 1900.0 | 1900.0 | 847.64 | 847.64 | 847.64 | 189 | 189 | 2024-07-31 |
| 1127642 | adb5756d13f8636e059d51693634b787f8246261767b31757001d3a31de1ac90 | 1 | 2022-01-27 | 2022-01-27 | 1400.0 | 1400.0 | 1400.0 | 337.93 | 337.93 | 337.93 | 0 | 0 | 2024-07-31 |
| 1127643 | 3d114dbdb742103cf82c7379a77214f15a31ceb28a76a9fb49c10eff7bba6680 | 1 | 2021-11-19 | 2021-11-19 | 1200.0 | 1200.0 | 1200.0 | -1.74 | -1.74 | -1.74 | 0 | 0 | 2024-07-31 |
| 1127644 | c2d6d6b9962c3f93e6190a120149e29fb7c19f8e6c90a3cbc534cc52a223fc0c | 1 | 2021-11-23 | 2021-11-23 | 500.0 | 500.0 | 500.0 | 0.00 | 0.00 | 0.00 | 595 | 595 | 2024-07-31 |
| 1127645 | cf70e6f942351f8437d5b7dd55f08ab5106c9eb99bbf83b895059b3b62ff78b3 | 1 | 2021-11-24 | 2021-11-24 | 3200.0 | 3200.0 | 3200.0 | 3851.28 | 3851.28 | 3851.28 | 260 | 260 | 2024-07-31 |
| 1127646 | a9d75e1fa655232405f3ca772ba868400fa901d8c5f4a988eaf98b1622ed1205 | 1 | 2021-11-30 | 2021-11-30 | 700.0 | 700.0 | 700.0 | 0.00 | 0.00 | 0.00 | 0 | 0 | 2024-07-31 |
| 1127647 | f315412b769ed0ff8eeda6fb9cb26317e79eb9f74600edde8ce33590fc5dc89b | 1 | 2021-12-01 | 2021-12-01 | 1900.0 | 1900.0 | 1900.0 | 1.57 | 1.57 | 1.57 | 0 | 0 | 2024-07-31 |
| 1127648 | 92dbec62fa1b3744a141d528d5c0d9d1765c44896f4fc4e06887fcc0749097b5 | 1 | 2021-12-01 | 2021-12-01 | 5900.0 | 5900.0 | 5900.0 | 1290.63 | 1290.63 | 1290.63 | 173 | 173 | 2024-07-31 |
| 1127649 | b38c98651c8a327de2997c561d38d5d1a95c130a7273e1e7ed3d606c1fbb17db | 1 | 2021-12-16 | 2021-12-16 | 600.0 | 600.0 | 600.0 | 0.00 | 0.00 | 0.00 | 753 | 753 | 2024-07-31 |